/*
MySQL Backup
Database: friday
Backup Time: 2024-05-10 14:00:33
*/
create database friday;
use friday;
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `friday`.`sys_config`;
DROP TABLE IF EXISTS `friday`.`sys_menu`;
DROP TABLE IF EXISTS `friday`.`sys_role`;
DROP TABLE IF EXISTS `friday`.`sys_role_menu`;
DROP TABLE IF EXISTS `friday`.`sys_user`;
DROP TABLE IF EXISTS `friday`.`sys_user_role`;
CREATE TABLE `sys_config` (
  `config_id` int NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='参数配置表';
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `is_frame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2006 DEFAULT CHARSET=utf8 COMMENT='菜单权限表';
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='角色信息表';
CREATE TABLE `sys_role_menu` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色和菜单关联表';
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(500) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(50) DEFAULT '' COMMENT '最后登陆IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COMMENT='用户信息表';
CREATE TABLE `sys_user_role` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户和角色关联表';
BEGIN;
LOCK TABLES `friday`.`sys_config` WRITE;
DELETE FROM `friday`.`sys_config`;
INSERT INTO `friday`.`sys_config` (`config_id`,`config_name`,`config_key`,`config_value`,`config_type`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '初始化密码 123456'),(3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '深色主题theme-dark，浅色主题theme-light')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `friday`.`sys_menu` WRITE;
DELETE FROM `friday`.`sys_menu`;
INSERT INTO `friday`.`sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`is_frame`,`menu_type`,`visible`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '系统管理', 0, 1, 'system', NULL, 1, 'M', '0', '', 'system', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '系统管理目录'),(2, '系统监控', 0, 2, 'monitor', NULL, 1, 'M', '1', '', 'monitor', 'admin', '2018-03-16 11:33:00', 'system', '2020-04-07 00:31:53', '系统监控目录'),(3, '系统工具', 0, 3, 'tool', NULL, 1, 'M', '0', '', 'tool', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '系统工具目录'),(100, '用户管理', 1, 1, 'user', 'system/user/index', 1, 'C', '0', 'system:user:list', 'user', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '用户管理菜单'),(101, '角色管理', 1, 2, 'role', 'system/role/index', 1, 'C', '0', 'system:role:list', 'peoples', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '角色管理菜单'),(102, '菜单管理', 1, 3, 'menu', 'system/menu/index', 1, 'C', '0', 'system:menu:list', 'tree-table', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '菜单管理菜单'),(105, '字典管理', 1, 6, 'dict', 'system/dict/index', 1, 'C', '1', 'system:dict:list', 'dict', 'admin', '2018-03-16 11:33:00', 'system', '2020-04-05 15:49:06', '字典管理菜单'),(109, '在线用户', 2, 1, 'online', 'monitor/online/index', 1, 'C', '0', 'monitor:online:list', 'online', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '在线用户菜单'),(110, '定时任务', 2, 2, 'job', 'monitor/job/index', 1, 'C', '1', 'monitor:job:list', 'job', 'admin', '2018-03-16 11:33:00', 'admin', '2020-03-11 23:50:50', '定时任务菜单'),(111, '数据监控', 3, 3, 'druid', 'tool/druid/index', 1, 'C', '0', 'monitor:druid:list', 'druid', 'admin', '2018-03-16 11:33:00', 'system', '2020-04-09 07:35:49', '数据监控菜单'),(112, '服务监控', 2, 4, 'server', 'monitor/server/index', 1, 'C', '1', 'monitor:server:list', 'server', 'admin', '2018-03-16 11:33:00', 'system', '2020-04-07 00:30:38', '服务监控菜单'),(115, '系统接口', 3, 3, 'swagger', 'tool/swagger/index', 1, 'C', '0', 'tool:swagger:list', 'swagger', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '系统接口菜单'),(500, '操作日志', 108, 1, 'operlog', 'monitor/operlog/index', 1, 'C', '0', 'monitor:operlog:list', 'form', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '操作日志菜单'),(501, '登录日志', 108, 2, 'logininfor', 'monitor/logininfor/index', 1, 'C', '0', 'monitor:logininfor:list', 'logininfor', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '登录日志菜单'),(1001, '用户查询', 100, 1, '', '', 1, 'F', '0', 'system:user:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1002, '用户新增', 100, 2, '', '', 1, 'F', '0', 'system:user:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1003, '用户修改', 100, 3, '', '', 1, 'F', '0', 'system:user:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1004, '用户删除', 100, 4, '', '', 1, 'F', '0', 'system:user:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1007, '重置密码', 100, 7, '', '', 1, 'F', '0', 'system:user:resetPwd', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1008, '角色查询', 101, 1, '', '', 1, 'F', '0', 'system:role:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1009, '角色新增', 101, 2, '', '', 1, 'F', '0', 'system:role:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1010, '角色修改', 101, 3, '', '', 1, 'F', '0', 'system:role:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1011, '角色删除', 101, 4, '', '', 1, 'F', '0', 'system:role:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1013, '菜单查询', 102, 1, '', '', 1, 'F', '0', 'system:menu:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1014, '菜单新增', 102, 2, '', '', 1, 'F', '0', 'system:menu:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1015, '菜单修改', 102, 3, '', '', 1, 'F', '0', 'system:menu:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1016, '菜单删除', 102, 4, '', '', 1, 'F', '0', 'system:menu:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1017, '部门查询', 103, 1, '', '', 1, 'F', '0', 'system:dept:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1018, '部门新增', 103, 2, '', '', 1, 'F', '0', 'system:dept:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1019, '部门修改', 103, 3, '', '', 1, 'F', '0', 'system:dept:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1020, '部门删除', 103, 4, '', '', 1, 'F', '0', 'system:dept:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1026, '字典查询', 105, 1, '#', '', 1, 'F', '0', 'system:dict:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1027, '字典新增', 105, 2, '#', '', 1, 'F', '0', 'system:dict:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1028, '字典修改', 105, 3, '#', '', 1, 'F', '0', 'system:dict:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1029, '字典删除', 105, 4, '#', '', 1, 'F', '0', 'system:dict:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1030, '字典导出', 105, 5, '#', '', 1, 'F', '0', 'system:dict:export', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1031, '参数查询', 106, 1, '#', '', 1, 'F', '0', 'system:config:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1032, '参数新增', 106, 2, '#', '', 1, 'F', '0', 'system:config:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1033, '参数修改', 106, 3, '#', '', 1, 'F', '0', 'system:config:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1034, '参数删除', 106, 4, '#', '', 1, 'F', '0', 'system:config:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1035, '参数导出', 106, 5, '#', '', 1, 'F', '0', 'system:config:export', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1036, '公告查询', 107, 1, '#', '', 1, 'F', '0', 'system:notice:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1037, '公告新增', 107, 2, '#', '', 1, 'F', '0', 'system:notice:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1038, '公告修改', 107, 3, '#', '', 1, 'F', '0', 'system:notice:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1039, '公告删除', 107, 4, '#', '', 1, 'F', '0', 'system:notice:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1040, '操作查询', 500, 1, '#', '', 1, 'F', '0', 'monitor:operlog:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1041, '操作删除', 500, 2, '#', '', 1, 'F', '0', 'monitor:operlog:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1042, '日志导出', 500, 4, '#', '', 1, 'F', '0', 'monitor:operlog:export', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1043, '登录查询', 501, 1, '#', '', 1, 'F', '0', 'monitor:logininfor:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1044, '登录删除', 501, 2, '#', '', 1, 'F', '0', 'monitor:logininfor:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1045, '日志导出', 501, 3, '#', '', 1, 'F', '0', 'monitor:logininfor:export', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1046, '在线查询', 109, 1, '#', '', 1, 'F', '0', 'monitor:online:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1047, '批量强退', 109, 2, '#', '', 1, 'F', '0', 'monitor:online:batchLogout', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1048, '单条强退', 109, 3, '#', '', 1, 'F', '0', 'monitor:online:forceLogout', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1049, '任务查询', 110, 1, '#', '', 1, 'F', '0', 'monitor:job:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1050, '任务新增', 110, 2, '#', '', 1, 'F', '0', 'monitor:job:add', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1051, '任务修改', 110, 3, '#', '', 1, 'F', '0', 'monitor:job:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1052, '任务删除', 110, 4, '#', '', 1, 'F', '0', 'monitor:job:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1053, '状态修改', 110, 5, '#', '', 1, 'F', '0', 'monitor:job:changeStatus', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1054, '任务导出', 110, 7, '#', '', 1, 'F', '0', 'monitor:job:export', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1055, '生成查询', 114, 1, '#', '', 1, 'F', '0', 'tool:gen:query', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1056, '生成修改', 114, 2, '#', '', 1, 'F', '0', 'tool:gen:edit', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1057, '生成删除', 114, 3, '#', '', 1, 'F', '0', 'tool:gen:remove', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1058, '导入代码', 114, 2, '#', '', 1, 'F', '0', 'tool:gen:import', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1059, '预览代码', 114, 4, '#', '', 1, 'F', '0', 'tool:gen:preview', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(1060, '生成代码', 114, 5, '#', '', 1, 'F', '0', 'tool:gen:code', '#', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', ''),(2000, 'test', 0, 0, 'system', NULL, 0, 'M', '1', '', 'theme', 'admin', '2020-03-14 16:29:13', 'system', '2020-04-07 00:33:53', ''),(2001, 'erter', 2000, 0, 'user', 'system/user/index', 1, 'C', '0', 'system:user:list', '404', 'admin', '2020-03-14 16:35:28', 'system', '2020-04-07 00:33:47', '')
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `friday`.`sys_role` WRITE;
DELETE FROM `friday`.`sys_role`;
INSERT INTO `friday`.`sys_role` (`role_id`,`role_name`,`role_key`,`role_sort`,`data_scope`,`status`,`del_flag`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, '管理员', 'admin', 1, '1', '0', '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '管理员'),(2, '普通角色', 'common', 2, '2', '0', '0', 'admin', '2018-03-16 11:33:00', 'system', '2020-04-02 07:58:06', '普通角色'),(100, '测试', 'test', 0, '1', '0', '0', 'admin', '2020-03-14 15:37:17', 'system', '2020-04-02 07:58:00', NULL),(101, 'tstere', 'dfdf', 3, '1', '0', '2', '', NULL, 'system', '2020-04-07 00:44:49', NULL),(102, 'sdfdf', 'sdf', 0, NULL, '0', '2', 'system', '2020-04-02 07:46:34', NULL, NULL, NULL),(103, '水电费', '说的话说的话 ', 0, NULL, '0', '2', 'system', '2020-04-03 07:51:06', 'system', '2020-04-03 07:54:39', NULL),(107, 'asdasd', 'asdasd', 0, NULL, '0', '2', 'system', '2020-04-03 07:58:37', NULL, NULL, NULL),(108, 'asdasd', 'asdasd', 0, NULL, '0', '2', 'system', '2020-04-03 07:58:37', NULL, NULL, NULL),(109, '奥迪', '奥迪', 0, NULL, '0', '2', 'system', '2020-04-03 07:59:05', NULL, NULL, NULL),(110, '教务', 'teacher', 0, NULL, '1', NULL, 'system', '2020-07-27 15:50:44', NULL, NULL, NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `friday`.`sys_role_menu` WRITE;
DELETE FROM `friday`.`sys_role_menu`;
INSERT INTO `friday`.`sys_role_menu` (`role_id`,`menu_id`) VALUES (1, 1),(1, 2),(1, 3),(1, 100),(1, 101),(1, 102),(1, 103),(1, 105),(1, 106),(1, 107),(1, 108),(1, 109),(1, 110),(1, 111),(1, 112),(1, 113),(1, 114),(1, 115),(1, 500),(1, 501),(1, 1001),(1, 1002),(1, 1003),(1, 1004),(1, 1007),(1, 1008),(1, 1009),(1, 1010),(1, 1011),(1, 1013),(1, 1014),(1, 1015),(1, 1016),(1, 1017),(1, 1018),(1, 1019),(1, 1020),(1, 1026),(1, 1027),(1, 1028),(1, 1029),(1, 1030),(1, 1031),(1, 1032),(1, 1033),(1, 1034),(1, 1035),(1, 1036),(1, 1037),(1, 1038),(1, 1039),(1, 1040),(1, 1041),(1, 1042),(1, 1043),(1, 1044),(1, 1045),(1, 1046),(1, 1047),(1, 1048),(1, 1049),(1, 1050),(1, 1051),(1, 1052),(1, 1053),(1, 1054),(1, 1055),(1, 1056),(1, 1057),(1, 1058),(1, 1059),(1, 1060),(1, 2000),(1, 2001)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `friday`.`sys_user` WRITE;
DELETE FROM `friday`.`sys_user`;
INSERT INTO `friday`.`sys_user` (`user_id`,`user_name`,`nick_name`,`user_type`,`email`,`phonenumber`,`sex`,`avatar`,`password`,`status`,`del_flag`,`login_ip`,`login_date`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (1, 'admin', 'alex', '00', 'alex@163.com', '15888888888', '1', 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$boXFAiZ4OdtZiT2owx.xx.F848I4rh4JCQQDvgAaEwiktcFRh8Ile', '0', '0', '127.0.0.1', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00', 'ry', '2020-03-15 17:33:47', '管理员'),(2, '元春', '元春', '00', 'yr@qq.com', '15666666666', '1', 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$LP25Pp2GITfV3QX6v.MmT.jV7vi.1rnQQJeeab3/AIyJn2.kPFiOq', '0', '0', '127.0.0.1', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00', 'admin', '2020-03-16 22:03:17', '测试员'),(100, '迎春', '迎春', '00', 'test@qq.com', '13192294560', '0', 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$fLcdPrdYZn9hNhTCFfMxBe0YhUYzDZgcvR89UGxDA.AnyzK1r6av.', '0', '2', '', NULL, 'admin', '2020-03-14 15:55:16', 'admin', '2020-03-14 15:58:17', NULL),(101, '探春', '探春', '00', '11@qqw.bb', '13111111111', '0', 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$EWDLVRkUmBX2If/eCgwjJODuDjAPiX7ZDKEDfTgfwrUh68/h3L/6S', '0', '0', '', NULL, 'admin', '2020-03-14 16:01:08', '', NULL, NULL),(102, '惜春', '惜春', '00', '22@Qq.mm', '13122222222', '0', 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$bws6QiPyKuqDGjgfivN6B.37WcvpUmyaj4RnmH3vHduSp7.nJXN7i', '0', '0', '', NULL, 'admin', '2020-03-14 16:01:50', '', NULL, NULL),(103, '秦可卿', '秦可卿', '00', '22@qq.com', '13222332222', '0', '', '$2a$10$bCUZogMaUn7Gmr3A2OE5Ue/PI3lqqRHJbVnS1b8bPB1smIXyIEOU6', '0', '2', '', NULL, 'admin', '2020-03-14 16:03:02', '', NULL, NULL),(104, '晴雯', '晴雯', '00', 'test1@qq.com', '13315554215', '0', '', '123456', '0', '0', '', NULL, 'admin', '2020-03-16 22:16:36', 'admin', '2020-03-16 22:22:44', NULL),(105, '贾政', '贾政', '00', 'l1_1_1@qq.com', '13192294561', '1', '', '123456', '0', '0', '', NULL, 'system', '2020-03-21 15:02:37', '', '2020-03-29 23:05:39', NULL),(109, '贾链', '贾链', '00', 'asd@q.com', '13311122311', NULL, NULL, '$2a$10$5F3q3LiCkvtMCdJlmG7BnOGN.XrIrjOsgbkNqih/KMZgzEh95uJsG', '0', '0', NULL, NULL, 'system', '2020-04-02 08:02:48', NULL, NULL, NULL),(111, '冷子兴', '冷子兴', '00', 'asd@q.com', '13311122311', NULL, NULL, '$2a$10$t66gnYmlYo8jBjdTTel0LeeSBUQ0vG186j6Eqjje8lbsctVz74g3y', '0', '0', NULL, NULL, 'system', '2020-04-02 08:02:48', NULL, NULL, NULL),(112, '贾雨村', '贾雨村', '00', 'asd@q.com', '13311122311', NULL, NULL, '$2a$10$mW9l7i7mlIS96LXfjzfSnuCfrv042Pr7yGhjw1wc/mc0dYbV2TRbe', '0', '0', NULL, NULL, 'system', '2020-04-02 08:02:48', NULL, NULL, NULL),(113, '贾宝玉', '贾宝玉', '00', 'asdasd@qq.com', '13122321123', NULL, NULL, '$2a$10$/47VtkXAXxw15JrcvzqK8OzDW0b5xGp8eS4oSw.v7SJNjycv15q3S', '0', '0', NULL, NULL, 'system', '2020-04-02 08:03:27', NULL, NULL, NULL),(114, '王熙风', '王熙风', '00', 'asdasda@qq.com', '13412311222', NULL, 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$wXRCV6ite.IjeRuhS8g5gOFqjkxBmvYCLVPsFYe/kiSL5Ho6VQKPK', '0', '0', NULL, NULL, 'system', '2020-04-02 08:06:55', NULL, NULL, NULL),(115, '妙玉', '妙玉', '00', 'del_flag@qq.com', '15312112311', NULL, 'https://wx.qlogo.cn/mmopen/vi_32/1yzTKJKIfurhDI29RqibEicNOoH0WiaCuKb6jWppVu4uzWovO0d1ICAwuW4rB4zfUxVvGHfNuxXLHu44t3yBkgbicQ/132', '$2a$10$5KlITzUxdpmeSTm4sx1wvuL5e8eaxrJAMDuXFn0QFL01tF3mwhXLm', '0', '0', NULL, NULL, 'system', '2020-04-02 08:08:59', NULL, NULL, NULL),(124, '234', '2413213', '00', '2@qq.com', '13523423523', NULL, NULL, '$2a$10$2b23r.tLlZyQP02uiDp49uZc04kOv9ZGE.HU4YEwpFBKzp5cWuhrC', '0', '2', NULL, NULL, 'system', '2020-07-26 09:55:59', NULL, NULL, NULL),(125, '甄士隐', '甄士隐', '00', 'a@qq.com', '13512312312', NULL, NULL, '$2a$10$AtE16A4t8gbVfB1xjl61hOfQyGZ9mPx1X8vlE1mEr/FbeFjORgPLa', '0', '0', NULL, NULL, 'system', '2020-07-26 09:58:41', NULL, NULL, NULL),(126, '123', 'asd', '00', 'a@qq.com', '13512312312', NULL, NULL, '$2a$10$3gKAwPznJyyMDXpGgm2bm.xWZz.RrkMBzdPgNU9RTzXCq6Ln9jFGu', '0', '2', NULL, NULL, 'system', '2020-07-26 09:59:16', NULL, NULL, NULL),(127, '123123', '11', '00', '11@qq.com', '13512312312', NULL, NULL, '$2a$10$UAMCS4ZFBq3u19nek0uzpepqc9Hpt3BtWJwmqP/fh/4ig16Ca7DCC', '0', '2', NULL, NULL, 'system', '2020-07-26 10:03:08', NULL, NULL, NULL),(128, 'alex123123', '222', '00', '222@qq.com', '13512321312', NULL, NULL, '$2a$10$boXFAiZ4OdtZiT2owx.xx.F848I4rh4JCQQDvgAaEwiktcFRh8Ile', '0', '0', NULL, NULL, 'system', '2020-07-26 10:05:54', NULL, NULL, NULL),(134, '10112', '10113', NULL, '11@qq.com', '13545679122', '0', NULL, '', '0', '2', NULL, NULL, 'system', '2020-10-11 17:25:08', 'system', '2020-10-11 17:31:20', NULL)
;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `friday`.`sys_user_role` WRITE;
DELETE FROM `friday`.`sys_user_role`;
INSERT INTO `friday`.`sys_user_role` (`user_id`,`role_id`) VALUES (1, 1),(2, 2),(100, 2),(104, 2),(109, 100),(110, 100),(111, 100),(112, 100),(115, 100),(123, 1),(129, 2),(130, 2),(131, 2),(132, 2),(133, 2),(134, 2),(233, 1),(233, 2)
;
UNLOCK TABLES;
COMMIT;
